home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
veventslist.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
2KB
|
53 lines
/*
This view collects data on events of certain types: shift start and end, Farebox door open and close, stacker cards, all alarms, all commands.
*/
create or replace view veventslist as
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, SHIFT_SEQ, USER_ID, ROUTE_ID,
RUN_ID, TRIP_ID, FARESET_ID ,' ' setclr, 0 alarm,'Shift Start' event
from shftstrt
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, SHIFT_SEQ, USER_ID, ROUTE_ID,
RUN_ID, TRIP_ID, FARESET_ID ,' ' setclr,0 alarm, 'Shift End ' event
from shftend
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, SHIFT_SEQ, USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID ,' ' setclr, 0 alarm,'ShiftRelStart' event
from shftrels
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, SHIFT_SEQ, USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr,0 alarm,'ShiftRelEnd ' event
from shftrele
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID ,' ' setclr, 0 alarm,'JCDoorOpen' event
from jcdooro
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr,0 alarm,'JCDoorClose' event
from jcdoorc
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , 'Act' setclr,alarmact.alarm_id alarm, descr event
from alarmact, alarmsg
where alarmact.alarm_id
in (14, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 34, 39 ) and
alarmact.alarm_id = alarmsg.alarm_id
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID ,'Clr' setclr, alarmclr.alarm_id alarm , descr event
from alarmclr, alarmsg
where
alarmclr.alarm_id in (14, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 34, 39 ) and alarmclr.alarm_id = alarmsg.alarm_id
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID ,' ' setclr, 0 alarm, 'AcceptStackerCard' event
from curacc where currency_type = 401 and currency_val = 0
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID ,' ' setclr, 0 alarm, ocucmnd.descr event
from ocucmnd, cmdinit
where cmdinit.command_id = ocucmnd.id and
ocucmnd.id in (7, 8, 9, 10);